package com.cc.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.cc.entity.Employees;

/**
 * @author hct
 * @description 针对表【employees】的数据库操作Mapper
 * @createDate 2024-10-21 08:45:38
 * @Entity com.cc.entity.Employees
 */
@Mapper
public interface EmployeesMapper {
    // 根据员工名和手机号查询
    List<Employees> selectAllByEmpNameAndPhoneNumber(@Param("empName") String empName, @Param("phoneNumber") String phoneNumber);

    // 批量插入
    int insertBatch(@Param("employeesCollection") List<Employees> employeesCollection);

    // 选择性修改
    int updateSelective(Employees employees);

    // 根据员工id删除
    int delByEmployeeId(@Param("employeeId") Integer employeeId);

    // 根据登录名和密码查询
    Employees selectAllByLoginNameAndPassword(@Param("loginName") String loginName,
                                              @Param("password") String password);

    Employees searchAllByEmployeeId(@Param("employeeId") Integer employeeId);

}




